Dan W
Dan W
Reactions
-
Re: Date+days not calculating correctly
Try moving like this =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Start Date]@row))) + 211 · -
Re: Help with COUNTIFS function
@Hannahsamd FYI the formula I posted had Stage as not blank as well. If that is not what you need then remove the first Stage:Stage, <>"", with the inclusion of Genevieve's addition i…1 · -
Re: Index Collect Error
Might be you need to move the first ) try this =INDEX(COLLECT({OPK Monthly Report 22-23 Unfilled 0-3}, {OPK Monthly Report 22-23 Month}, "April", {OPK Monthly Report 22-23 Grantee Name}, Gr…1 · -
Re: IF OR Statement For % of completion
IFERROR Works a little differently. Usually combined with more complications. For something simpler you would use IF =IF([% Complete]@row = 1, "Complete", "In Progress") This form…1 · -
Re: Count values in a column based on values in a different column
@Chris St. Louis Try this =COUNTIFS(Status:Status, OR(@cell = "OPEN", @cell = "INVESTIGATING", @cell = "ESCALATED"), Priority:Priority, ="High") Replace the st…1 ·
